Aspect Extraction and Sentiment Analysis of Google Reviews

Part1: Aspect Extraction

Customer reviews in tabular form

User Date Review Likes Response Response_Date Rating
0 haru maru 2024-06-25 Prices be high any time i ask why i be give th... Like Hello. We're very sorry to hear about your exp... a week ago 1
1 The Luxury Spa 2024-05-09 service be horrible I have never see a Utility... 3 Hello. We're very sorry to hear about your exp... 2 months ago 1
2 Sam Peachey 2024-06-09 If you have the option of use RG&E do not . I ... 5 We're very sorry to hear about your experience... a month ago 1
3 Ms M 2024-06-09 They tell you to enter a meter read .. I do it... 3 We're very sorry to hear about your experience... a month ago 2
4 Phoebe Hernick 2024-05-09 I schedule a meter reading , and the meter rea... 2 Hi Phoebe. If you need assistance, please cont... 2 months ago 1
5 Rochelle Marie 2024-01-09 This a ZERO star review . Worst RG&E ever . Ho... 16 NaN NaN 1
6 Cakes Blue 2024-01-09 First three month of living at my new place . ... 7 NaN NaN 1
7 Nathan Scott 2024-03-09 My bill have go from about $ 80 a month to ove... 2 Hi Nathan. We're very sorry to hear about your... 4 months ago 1
8 Kim Ganley 2024-06-09 RG&E be terribly inefficient . I do not know h... 1 Hi Kim. We're very sorry to hear about your ex... a month ago 1
9 MEHRI DALAI 2024-03-09 0 star ! This dumb , scamming donkey behind RG... 1 Hi Mehri. We're very sorry to hear about your ... 4 months ago 1

Top Aspect phrases used by customers in the review:



  1. RGE
  2. Service
  3. Bill
  4. Representative
EXAMPLE

Summary: the descriptions used for each term shows that customers are unhappy.

Aspect Sentiment analyzer

Summary:

Sentiments associated with each aspect shows that there are more negative sentiments than positive sentiments for each term.